Pandas Profiling Report

Dataset statistics

Number of variables	31
Number of observations	450000
Missing cells	1946668
Missing cells (%)	14.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	106.4 MiB
Average record size in memory	248.0 B

Variable types

DateTime	7
Numeric	17
Categorical	7

Alerts

`first_mile_distance` is highly correlated with `total_dist`	High correlation
`last_mile_distance` is highly correlated with `total_dist`	High correlation
`alloted_orders` is highly correlated with `delivered_orders` and 2 other fields	High correlation
`delivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`undelivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`lifetime_order_count` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`total_dist` is highly correlated with `first_mile_distance` and 1 other fields	High correlation
`order_time_hour` is highly correlated with `accept_time_hour` and 1 other fields	High correlation
`accept_time_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`delivered_fraction` is highly correlated with `undelivered_orders`	High correlation
`cancelled_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`first_mile_distance` is highly correlated with `total_dist`	High correlation
`last_mile_distance` is highly correlated with `total_dist`	High correlation
`alloted_orders` is highly correlated with `delivered_orders`	High correlation
`delivered_orders` is highly correlated with `alloted_orders`	High correlation
`reassigned_order` is highly correlated with `accept_order_diff`	High correlation
`total_dist` is highly correlated with `first_mile_distance` and 1 other fields	High correlation
`order_time_hour` is highly correlated with `accept_time_hour` and 1 other fields	High correlation
`accept_time_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`accept_order_diff` is highly correlated with `reassigned_order`	High correlation
`cancelled_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`last_mile_distance` is highly correlated with `total_dist`	High correlation
`alloted_orders` is highly correlated with `delivered_orders`	High correlation
`delivered_orders` is highly correlated with `alloted_orders`	High correlation
`undelivered_orders` is highly correlated with `delivered_fraction`	High correlation
`total_dist` is highly correlated with `last_mile_distance`	High correlation
`order_time_hour` is highly correlated with `accept_time_hour` and 1 other fields	High correlation
`accept_time_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`delivered_fraction` is highly correlated with `undelivered_orders`	High correlation
`cancelled_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`reassignment_method` is highly correlated with `reassigned_order`	High correlation
`reassigned_order` is highly correlated with `reassignment_method` and 1 other fields	High correlation
`reassignment_reason` is highly correlated with `reassigned_order`	High correlation
`order_id` is highly correlated with `order_date` and 2 other fields	High correlation
`order_date` is highly correlated with `order_id` and 2 other fields	High correlation
`first_mile_distance` is highly correlated with `total_dist`	High correlation
`last_mile_distance` is highly correlated with `total_dist`	High correlation
`alloted_orders` is highly correlated with `delivered_orders` and 1 other fields	High correlation
`delivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`undelivered_orders` is highly correlated with `alloted_orders` and 1 other fields	High correlation
`session_time` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`total_dist` is highly correlated with `first_mile_distance` and 1 other fields	High correlation
`weekday` is highly correlated with `order_id` and 2 other fields	High correlation
`order_time_hour` is highly correlated with `session_time` and 2 other fields	High correlation
`accept_time_hour` is highly correlated with `session_time` and 2 other fields	High correlation
`weekday_num` is highly correlated with `order_id` and 2 other fields	High correlation
`cancelled_hour` is highly correlated with `order_time_hour` and 1 other fields	High correlation
`delivered_time` has 5218 (1.2%) missing values	Missing
`reassignment_method` has 436256 (96.9%) missing values	Missing
`reassignment_reason` has 436247 (96.9%) missing values	Missing
`cancelled_time` has 444782 (98.8%) missing values	Missing
`delivered_fraction` has 16948 (3.8%) missing values	Missing
`call_total` has 159543 (35.5%) missing values	Missing
`cancelled_hour` has 444782 (98.8%) missing values	Missing
`alloted_orders` has 16948 (3.8%) zeros	Zeros
`delivered_orders` has 17341 (3.9%) zeros	Zeros
`undelivered_orders` has 250027 (55.6%) zeros	Zeros
`weekday_num` has 37833 (8.4%) zeros	Zeros

Reproduction

Analysis started	2022-02-16 15:55:00.593392
Analysis finished	2022-02-16 15:56:58.380001
Duration	1 minute and 57.79 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

order_time
Date

Distinct	252868
Distinct (%)	56.2%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

Minimum	2021-01-26 02:21:35
Maximum	2021-02-06 10:03:24

Histogram

Histogram with fixed size bins (bins=50)

order_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	449999
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	369143.0808

Minimum	118350
Maximum	594842
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	118350
5-th percentile	167343.95
Q1	257342.75
median	369842.5
Q3	482342.25
95-th percentile	572342.05
Maximum	594842
Range	476492
Interquartile range (IQR)	224999.5

Descriptive statistics

Standard deviation	131146.9064
Coefficient of variation (CV)	0.355273912
Kurtosis	-1.149146297
Mean	369143.0808
Median Absolute Deviation (MAD)	112500
Skewness	-0.03426737717
Sum	1.661143863 × 10¹¹
Variance	1.719951106 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
181402	2	< 0.1%
556753	1	< 0.1%
306422	1	< 0.1%
306433	1	< 0.1%
306430	1	< 0.1%
306429	1	< 0.1%
306428	1	< 0.1%
306431	1	< 0.1%
306432	1	< 0.1%
306427	1	< 0.1%
Other values (449989)	449989	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
118350	1	< 0.1%
118351	1	< 0.1%
118352	1	< 0.1%
118353	1	< 0.1%
118354	1	< 0.1%
118355	1	< 0.1%
118356	1	< 0.1%
118357	1	< 0.1%
118358	1	< 0.1%
118359	1	< 0.1%

Value	Count	Frequency (%)
594842	1	< 0.1%
594841	1	< 0.1%
594840	1	< 0.1%
594839	1	< 0.1%
594838	1	< 0.1%
594837	1	< 0.1%
594836	1	< 0.1%
594835	1	< 0.1%
594834	1	< 0.1%
594833	1	< 0.1%

order_date
Date

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

Minimum	2021-01-26 00:00:00
Maximum	2021-02-06 00:00:00

Histogram

Histogram with fixed size bins (bins=12)

allot_time
Date

Distinct	246871
Distinct (%)	54.9%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

Minimum	2021-01-26 02:21:59
Maximum	2021-02-06 10:52:57

Histogram

Histogram with fixed size bins (bins=50)

accept_time
Date

Distinct	254201
Distinct (%)	56.5%
Missing	157
Missing (%)	< 0.1%
Memory size	3.4 MiB

Minimum	2021-01-26 02:22:08
Maximum	2021-02-06 10:53:03

Histogram

Histogram with fixed size bins (bins=50)

pickup_time
Date

Distinct	257117
Distinct (%)	57.4%
Missing	2421
Missing (%)	0.5%
Memory size	3.4 MiB

Minimum	2021-01-26 02:32:51
Maximum	2021-02-08 07:52:34

Histogram

Histogram with fixed size bins (bins=50)

delivered_time
Date

MISSING

Distinct	257067
Distinct (%)	57.8%
Missing	5218
Missing (%)	1.2%
Memory size	3.4 MiB

Minimum	2021-01-26 02:49:47
Maximum	2021-02-08 16:19:04

Histogram

Histogram with fixed size bins (bins=50)

rider_id
Real number (ℝ_≥0)

Distinct	19537
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7763.244016

Minimum	0
Maximum	21566
Zeros	7
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	519
Q1	2805
median	6754
Q3	11965
95-th percentile	18050
Maximum	21566
Range	21566
Interquartile range (IQR)	9160

Descriptive statistics

Standard deviation	5592.880135
Coefficient of variation (CV)	0.7204308049
Kurtosis	-0.8427443266
Mean	7763.244016
Median Absolute Deviation (MAD)	4436
Skewness	0.4790871039
Sum	3493459807
Variance	31280308.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
237	228	0.1%
190	213	< 0.1%
11998	209	< 0.1%
170	203	< 0.1%
853	200	< 0.1%
747	199	< 0.1%
2280	195	< 0.1%
4921	194	< 0.1%
12709	191	< 0.1%
453	190	< 0.1%
Other values (19527)	447978	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	16	< 0.1%
2	28	< 0.1%
4	3	< 0.1%
5	19	< 0.1%
6	15	< 0.1%
9	29	< 0.1%
10	97	< 0.1%
11	25	< 0.1%
12	24	< 0.1%

Value	Count	Frequency (%)
21566	1	< 0.1%
21565	1	< 0.1%
21564	1	< 0.1%
21563	1	< 0.1%
21562	1	< 0.1%
21561	1	< 0.1%
21560	2	< 0.1%
21559	2	< 0.1%
21558	2	< 0.1%
21557	1	< 0.1%

first_mile_distance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	93743
Distinct (%)	20.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.229888977

Minimum	0.0001342587859
Maximum	42.0381
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0.0001342587859
5-th percentile	0.05458151785
Q1	0.539575
median	1.1387
Q3	1.853
95-th percentile	2.7079
Maximum	42.0381
Range	42.03796574
Interquartile range (IQR)	1.313425

Descriptive statistics

Standard deviation	0.8461826096
Coefficient of variation (CV)	0.688015443
Kurtosis	12.36678626
Mean	1.229888977
Median Absolute Deviation (MAD)	0.6482
Skewness	0.7588916893
Sum	553450.0398
Variance	0.7160250088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7153	39	< 0.1%
0.7404	39	< 0.1%
0.6965	36	< 0.1%
0.6959	36	< 0.1%
0.7241	34	< 0.1%
0.6578	34	< 0.1%
0.6883	34	< 0.1%
1.0009	34	< 0.1%
1.5356	34	< 0.1%
0.6174	34	< 0.1%
Other values (93733)	449646	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0001342587859	2	< 0.1%
0.0002122817797	1	< 0.1%
0.0002848058939	1	< 0.1%
0.000328865519	1	< 0.1%
0.0003797411919	2	< 0.1%
0.0004027763578	5	< 0.1%
0.00041381337	1	< 0.1%
0.0004452860177	2	< 0.1%
0.0004552936947	3	< 0.1%
0.0004650860772	2	< 0.1%

Value	Count	Frequency (%)
42.0381	1	< 0.1%
17.3442	1	< 0.1%
11.6741	1	< 0.1%
11.3649	1	< 0.1%
10.7525	1	< 0.1%
10.6994	1	< 0.1%
10.5839	1	< 0.1%
10.0546	1	< 0.1%
9.6695	1	< 0.1%
9.6079	1	< 0.1%

last_mile_distance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1331
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.968872711

Minimum	0
Maximum	22.41
Zeros	94
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	1.47
median	2.67
Q3	4.22
95-th percentile	6.22
Maximum	22.41
Range	22.41
Interquartile range (IQR)	2.75

Descriptive statistics

Standard deviation	1.884123753
Coefficient of variation (CV)	0.6346259797
Kurtosis	0.8795462088
Mean	2.968872711
Median Absolute Deviation (MAD)	1.33
Skewness	0.8267706027
Sum	1335992.72
Variance	3.549922316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.58	1143	0.3%
1.5	1121	0.2%
1.97	1119	0.2%
1.45	1111	0.2%
1.63	1110	0.2%
1.46	1109	0.2%
1.54	1107	0.2%
1.32	1105	0.2%
1.76	1104	0.2%
1.67	1104	0.2%
Other values (1321)	438867	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	94	< 0.1%
0.01	170	< 0.1%
0.02	210	< 0.1%
0.03	193	< 0.1%
0.04	237	0.1%
0.05	253	0.1%
0.06	291	0.1%
0.07	353	0.1%
0.08	415	0.1%
0.09	482	0.1%

Value	Count	Frequency (%)
22.41	1	< 0.1%
22.26	1	< 0.1%
21.27	1	< 0.1%
21.21	1	< 0.1%
21.2	1	< 0.1%
21.12	1	< 0.1%
19.81	1	< 0.1%
18.13	1	< 0.1%
17.27	1	< 0.1%
16.85	1	< 0.1%

alloted_orders
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	511
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.6806533

Minimum	0
Maximum	567
Zeros	16948
Zeros (%)	3.8%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	31
median	77
Q3	144
95-th percentile	286
Maximum	567
Range	567
Interquartile range (IQR)	113

Descriptive statistics

Standard deviation	90.63736221
Coefficient of variation (CV)	0.9002460673
Kurtosis	2.094703755
Mean	100.6806533
Median Absolute Deviation (MAD)	53
Skewness	1.382605843
Sum	45306294
Variance	8215.131429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16948	3.8%
6	3764	0.8%
5	3717	0.8%
4	3648	0.8%
2	3589	0.8%
7	3586	0.8%
3	3513	0.8%
10	3424	0.8%
8	3309	0.7%
9	3168	0.7%
Other values (501)	401334	89.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16948	3.8%
1	2991	0.7%
2	3589	0.8%
3	3513	0.8%
4	3648	0.8%
5	3717	0.8%
6	3764	0.8%
7	3586	0.8%
8	3309	0.7%
9	3168	0.7%

Value	Count	Frequency (%)
567	12	< 0.1%
565	18	< 0.1%
563	17	< 0.1%
561	18	< 0.1%
558	9	< 0.1%
555	25	< 0.1%
553	21	< 0.1%
545	28	< 0.1%
540	21	< 0.1%
536	20	< 0.1%

delivered_orders
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	505
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.94466

Minimum	0
Maximum	562
Zeros	17341
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	31
median	77
Q3	143
95-th percentile	284
Maximum	562
Range	562
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	90.14421802
Coefficient of variation (CV)	0.9019413145
Kurtosis	2.113953265
Mean	99.94466
Median Absolute Deviation (MAD)	52
Skewness	1.387814359
Sum	44975097
Variance	8125.980042
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	17341	3.9%
6	3798	0.8%
4	3698	0.8%
5	3697	0.8%
7	3645	0.8%
3	3528	0.8%
2	3525	0.8%
10	3403	0.8%
8	3322	0.7%
13	3228	0.7%
Other values (495)	400815	89.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	17341	3.9%
1	2949	0.7%
2	3525	0.8%
3	3528	0.8%
4	3698	0.8%
5	3697	0.8%
6	3798	0.8%
7	3645	0.8%
8	3322	0.7%
9	3180	0.7%

Value	Count	Frequency (%)
562	12	< 0.1%
560	18	< 0.1%
559	17	< 0.1%
557	18	< 0.1%
553	9	< 0.1%
550	25	< 0.1%
548	21	< 0.1%
540	28	< 0.1%
535	21	< 0.1%
531	20	< 0.1%

cancelled
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

0	444782
1	5218

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	444782	98.8%
1	5218	1.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	444782	98.8%
1	5218	1.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

undelivered_orders
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7347177778

Minimum	0
Maximum	9
Zeros	250027
Zeros (%)	55.6%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	9
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.056017171
Coefficient of variation (CV)	1.437309948
Kurtosis	4.89193206
Mean	0.7347177778
Median Absolute Deviation (MAD)	0
Skewness	1.89921989
Sum	330623
Variance	1.115172265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	250027	55.6%
1	118103	26.2%
2	50582	11.2%
3	20011	4.4%
4	7733	1.7%
5	1851	0.4%
6	932	0.2%
7	600	0.1%
8	105	< 0.1%
9	56	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	250027	55.6%
1	118103	26.2%
2	50582	11.2%
3	20011	4.4%
4	7733	1.7%
5	1851	0.4%
6	932	0.2%
7	600	0.1%
8	105	< 0.1%
9	56	< 0.1%

Value	Count	Frequency (%)
9	56	< 0.1%
8	105	< 0.1%
7	600	0.1%
6	932	0.2%
5	1851	0.4%
4	7733	1.7%
3	20011	4.4%
2	50582	11.2%
1	118103	26.2%
0	250027	55.6%

lifetime_order_count
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2887
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	853.5401244

Minimum	0
Maximum	30469
Zeros	58
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	165
median	396
Q3	948
95-th percentile	3013
Maximum	30469
Range	30469
Interquartile range (IQR)	783

Descriptive statistics

Standard deviation	1502.9162
Coefficient of variation (CV)	1.760803221
Kurtosis	77.97124105
Mean	853.5401244
Median Absolute Deviation (MAD)	287
Skewness	6.75716413
Sum	384093056
Variance	2258757.105
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	1609	0.4%
51	1230	0.3%
290	1201	0.3%
130	1170	0.3%
166	1162	0.3%
228	1161	0.3%
99	1104	0.2%
84	1091	0.2%
57	1086	0.2%
106	1084	0.2%
Other values (2877)	438102	97.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	58	< 0.1%
1	172	< 0.1%
2	232	0.1%
3	293	0.1%
4	280	0.1%
5	381	0.1%
6	344	0.1%
7	428	0.1%
8	369	0.1%
9	375	0.1%

Value	Count	Frequency (%)
30469	50	< 0.1%
27972	55	< 0.1%
26810	26	< 0.1%
24933	4	< 0.1%
24022	80	< 0.1%
23626	33	< 0.1%
22581	34	< 0.1%
22033	27	< 0.1%
21995	10	< 0.1%
21938	7	< 0.1%

reassignment_method
Categorical

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	436256
Missing (%)	96.9%
Memory size	3.4 MiB

auto	13383
manual	361

Length

Max length	6
Median length	4
Mean length	4.052532014
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	auto
2nd row	auto
3rd row	auto
4th row	auto
5th row	auto

Common Values

Value	Count	Frequency (%)
auto	13383	3.0%
manual	361	0.1%
(Missing)	436256	96.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
auto	13383	97.4%
manual	361	2.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

reassignment_reason
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	436247
Missing (%)	96.9%
Memory size	3.4 MiB

Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket	7212
Reassignment Request from SE portal.	5300
Reassign	1241

Length

Max length	76
Median length	76
Mean length	54.44921108
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Reassignment Request from SE portal.
2nd row	Reassignment Request from SE portal.
3rd row	Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket
4th row	Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket
5th row	Reassignment Request from SE portal.

Common Values

Value	Count	Frequency (%)
Auto Reassignment basis Inaction. coreengine.tasks.repush_order_to_aa_bucket	7212	1.6%
Reassignment Request from SE portal.	5300	1.2%
Reassign	1241	0.3%
(Missing)	436247	96.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
reassignment	12512	19.6%
auto	7212	11.3%
basis	7212	11.3%
inaction	7212	11.3%
coreengine.tasks.repush_order_to_aa_bucket	7212	11.3%
request	5300	8.3%
from	5300	8.3%
se	5300	8.3%
portal	5300	8.3%
reassign	1241	1.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

reassigned_order
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

0.0	436247
1.0	13753

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	436247	96.9%
1.0	13753	3.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0.0	436247	96.9%
1.0	13753	3.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

session_time
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	65872
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	220.1078929

Minimum	0
Maximum	1298.966667
Zeros	16
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	9.949166667
Q1	84.85
median	175.55
Q3	314.6875
95-th percentile	580.5008333
Maximum	1298.966667
Range	1298.966667
Interquartile range (IQR)	229.8375

Descriptive statistics

Standard deviation	176.0372292
Coefficient of variation (CV)	0.7997769952
Kurtosis	0.3322033297
Mean	220.1078929
Median Absolute Deviation (MAD)	103.2333333
Skewness	0.9955830323
Sum	99048551.78
Variance	30989.10605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
175.55	3697	0.8%
0.06666666667	155	< 0.1%
0.03333333333	144	< 0.1%
0.1166666667	136	< 0.1%
0.15	132	< 0.1%
0.05	129	< 0.1%
0.08333333333	124	< 0.1%
240	120	< 0.1%
0.1	118	< 0.1%
0.1333333333	117	< 0.1%
Other values (65862)	445128	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16	< 0.1%
0.01666666667	115	< 0.1%
0.03333333333	144	< 0.1%
0.05	129	< 0.1%
0.06666666667	155	< 0.1%
0.08333333333	124	< 0.1%
0.1	118	< 0.1%
0.1166666667	136	< 0.1%
0.1333333333	117	< 0.1%
0.15	132	< 0.1%

Value	Count	Frequency (%)
1298.966667	1	< 0.1%
1294.433333	1	< 0.1%
1250.333333	1	< 0.1%
1183.566667	1	< 0.1%
1141.533333	1	< 0.1%
1096.833333	1	< 0.1%
1076.85	1	< 0.1%
1057.483333	1	< 0.1%
1043.866667	1	< 0.1%
1038.216667	1	< 0.1%

cancelled_time
Date

MISSING

Distinct	5176
Distinct (%)	99.2%
Missing	444782
Missing (%)	98.8%
Memory size	3.4 MiB

Minimum	2021-01-26 04:08:50
Maximum	2021-02-07 10:04:25

Histogram

Histogram with fixed size bins (bins=50)

total_dist
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	187961
Distinct (%)	41.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.198761688

Minimum	0.003223609088
Maximum	45.8281
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0.003223609088
5-th percentile	1.143691697
Q1	2.5178
median	3.9779
Q3	5.6016
95-th percentile	7.9983
Maximum	45.8281
Range	45.82487639
Interquartile range (IQR)	3.0838

Descriptive statistics

Standard deviation	2.163998339
Coefficient of variation (CV)	0.5153896552
Kurtosis	0.8577599078
Mean	4.198761688
Median Absolute Deviation (MAD)	1.531
Skewness	0.669952122
Sum	1889442.76
Variance	4.68288881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.2972	20	< 0.1%
4.7797	18	< 0.1%
3.6433	17	< 0.1%
3.8197	16	< 0.1%
3.1253	16	< 0.1%
3.1886	16	< 0.1%
3.7092	16	< 0.1%
4.0858	16	< 0.1%
3.2096	16	< 0.1%
4.2522	15	< 0.1%
Other values (187951)	449834	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.003223609088	1	< 0.1%
0.008991831214	1	< 0.1%
0.0121958598	1	< 0.1%
0.01771045909	1	< 0.1%
0.01779741926	1	< 0.1%
0.0209460918	1	< 0.1%
0.02390761613	1	< 0.1%
0.02566731646	1	< 0.1%
0.02574129946	1	< 0.1%
0.02729673192	1	< 0.1%

Value	Count	Frequency (%)
45.8281	1	< 0.1%
23.4694	1	< 0.1%
23.1514	1	< 0.1%
23.1353	1	< 0.1%
22.9468	1	< 0.1%
22.9131	1	< 0.1%
21.8706	1	< 0.1%
21.5442	1	< 0.1%
21.5325	1	< 0.1%
19.0825	1	< 0.1%

weekday
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

Friday	83548
Thursday	80468
Wednesday	80462
Tuesday	78965
Saturday	49470
Other values (2)	77087

Length

Max length	9
Median length	7
Mean length	7.289393333
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Tuesday
2nd row	Tuesday
3rd row	Tuesday
4th row	Tuesday
5th row	Tuesday

Common Values

Value	Count	Frequency (%)
Friday	83548	18.6%
Thursday	80468	17.9%
Wednesday	80462	17.9%
Tuesday	78965	17.5%
Saturday	49470	11.0%
Sunday	39254	8.7%
Monday	37833	8.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
friday	83548	18.6%
thursday	80468	17.9%
wednesday	80462	17.9%
tuesday	78965	17.5%
saturday	49470	11.0%
sunday	39254	8.7%
monday	37833	8.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_time_hour
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.7238

Minimum	0
Maximum	21
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	9
median	14
Q3	16
95-th percentile	17
Maximum	21
Range	21
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.619623125
Coefficient of variation (CV)	0.2844765813
Kurtosis	-0.9800672739
Mean	12.7238
Median Absolute Deviation (MAD)	2
Skewness	-0.64855338
Sum	5725710
Variance	13.10167156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
14	70587	15.7%
16	66326	14.7%
15	66184	14.7%
17	53648	11.9%
13	43407	9.6%
7	37651	8.4%
8	37553	8.3%
6	22886	5.1%
9	22245	4.9%
12	9262	2.1%
Other values (12)	20251	4.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	2	< 0.1%
2	61	< 0.1%
3	645	0.1%
4	1211	0.3%
5	1089	0.2%
6	22886	5.1%
7	37651	8.4%
8	37553	8.3%
9	22245	4.9%

Value	Count	Frequency (%)
21	2	< 0.1%
20	8	< 0.1%
19	25	< 0.1%
18	168	< 0.1%
17	53648	11.9%
16	66326	14.7%
15	66184	14.7%
14	70587	15.7%
13	43407	9.6%
12	9262	2.1%

accept_time_hour
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	22
Distinct (%)	< 0.1%
Missing	157
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	12.7613434

Minimum	0
Maximum	21
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	9
median	14
Q3	16
95-th percentile	17
Maximum	21
Range	21
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.621517342
Coefficient of variation (CV)	0.2837880956
Kurtosis	-0.9784375606
Mean	12.7613434
Median Absolute Deviation (MAD)	2
Skewness	-0.6478898375
Sum	5740601
Variance	13.11538786
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
14	69627	15.5%
15	67104	14.9%
16	66439	14.8%
17	54529	12.1%
13	41459	9.2%
7	37584	8.4%
8	37458	8.3%
9	23217	5.2%
6	21664	4.8%
12	9222	2.0%
Other values (12)	21540	4.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	2	< 0.1%
2	57	< 0.1%
3	592	0.1%
4	1211	0.3%
5	1092	0.2%
6	21664	4.8%
7	37584	8.4%
8	37458	8.3%
9	23217	5.2%

Value	Count	Frequency (%)
21	2	< 0.1%
20	8	< 0.1%
19	31	< 0.1%
18	1422	0.3%
17	54529	12.1%
16	66439	14.8%
15	67104	14.9%
14	69627	15.5%
13	41459	9.2%
12	9222	2.0%

first_order
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

1	449942
0	58

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	449942	> 99.9%
0	58	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	449942	> 99.9%
0	58	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

cancel_before_accept
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

0	449843
1	157

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	449843	> 99.9%
1	157	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	449843	> 99.9%
1	157	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

delivered_fraction
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1335
Distinct (%)	0.3%
Missing	16948
Missing (%)	3.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.9901580054

Minimum	0
Maximum	1
Zeros	393
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0.9655172414
Q1	0.9887640449
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.01123595506

Descriptive statistics

Standard deviation	0.03795187824
Coefficient of variation (CV)	0.03832911316
Kurtosis	450.6018829
Mean	0.9901580054
Median Absolute Deviation (MAD)	0
Skewness	-18.87983676
Sum	428789.9046
Variance	0.001440345062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	232686	51.7%
0.98	1184	0.3%
0.9777777778	1145	0.3%
0.9818181818	1139	0.3%
0.9821428571	1138	0.3%
0.9866666667	1136	0.3%
0.9887640449	1094	0.2%
0.9787234043	1094	0.2%
0.9875	1087	0.2%
0.984375	1083	0.2%
Other values (1325)	190266	42.3%
(Missing)	16948	3.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	393	0.1%
0.1666666667	2	< 0.1%
0.25	6	< 0.1%
0.3333333333	41	< 0.1%
0.4	10	< 0.1%
0.4285714286	1	< 0.1%
0.5	224	< 0.1%
0.5714285714	1	< 0.1%
0.6	21	< 0.1%
0.625	8	< 0.1%

Value	Count	Frequency (%)
1	232686	51.7%
0.998015873	13	< 0.1%
0.998003992	7	< 0.1%
0.9979919679	42	< 0.1%
0.997983871	28	< 0.1%
0.9979716024	21	< 0.1%
0.9979674797	8	< 0.1%
0.9979381443	16	< 0.1%
0.9979166667	22	< 0.1%
0.9979079498	13	< 0.1%

accept_order_diff
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	3243
Distinct (%)	0.7%
Missing	157
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	134.0647004

Minimum	2
Maximum	15598
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	33
median	64
Q3	112
95-th percentile	517
Maximum	15598
Range	15596
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	283.955722
Coefficient of variation (CV)	2.118049876
Kurtosis	113.6159176
Mean	134.0647004
Median Absolute Deviation (MAD)	37
Skewness	8.052822639
Sum	60308067
Variance	80630.85206
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	5801	1.3%
9	5616	1.2%
10	5581	1.2%
7	5356	1.2%
11	5136	1.1%
12	4881	1.1%
13	4636	1.0%
14	4551	1.0%
15	4423	1.0%
6	4340	1.0%
Other values (3233)	399522	88.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	68	< 0.1%
4	759	0.2%
5	2329	0.5%
6	4340	1.0%
7	5356	1.2%
8	5801	1.3%
9	5616	1.2%
10	5581	1.2%
11	5136	1.1%

Value	Count	Frequency (%)
15598	1	< 0.1%
7905	1	< 0.1%
7726	1	< 0.1%
7708	1	< 0.1%
7704	1	< 0.1%
7452	1	< 0.1%
7442	1	< 0.1%
7303	1	< 0.1%
7178	1	< 0.1%
7039	1	< 0.1%

weekday_num
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.885242222

Minimum	0
Maximum	6
Zeros	37833
Zeros (%)	8.4%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.742035737
Coefficient of variation (CV)	0.6037745196
Kurtosis	-0.9533035557
Mean	2.885242222
Median Absolute Deviation (MAD)	1
Skewness	0.116151224
Sum	1298359
Variance	3.034688507
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	83548	18.6%
3	80468	17.9%
2	80462	17.9%
1	78965	17.5%
5	49470	11.0%
6	39254	8.7%
0	37833	8.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37833	8.4%
1	78965	17.5%
2	80462	17.9%
3	80468	17.9%
4	83548	18.6%
5	49470	11.0%
6	39254	8.7%

Value	Count	Frequency (%)
6	39254	8.7%
5	49470	11.0%
4	83548	18.6%
3	80468	17.9%
2	80462	17.9%
1	78965	17.5%
0	37833	8.4%

call_total
Real number (ℝ_≥0)

MISSING

Distinct	45
Distinct (%)	< 0.1%
Missing	159543
Missing (%)	35.5%
Infinite	0
Infinite (%)	0.0%
Mean	1.472162833

Minimum	1
Maximum	67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	67
Range	66
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.132203578
Coefficient of variation (CV)	0.769074964
Kurtosis	191.2203067
Mean	1.472162833
Median Absolute Deviation (MAD)	0
Skewness	8.377347618
Sum	427600
Variance	1.281884942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
1	207777	46.2%
2	56033	12.5%
3	15361	3.4%
4	5644	1.3%
5	2377	0.5%
6	1232	0.3%
7	669	0.1%
8	435	0.1%
9	270	0.1%
10	177	< 0.1%
Other values (35)	482	0.1%
(Missing)	159543	35.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	207777	46.2%
2	56033	12.5%
3	15361	3.4%
4	5644	1.3%
5	2377	0.5%
6	1232	0.3%
7	669	0.1%
8	435	0.1%
9	270	0.1%
10	177	< 0.1%

Value	Count	Frequency (%)
67	1	< 0.1%
57	1	< 0.1%
53	1	< 0.1%
48	1	< 0.1%
46	1	< 0.1%
45	1	< 0.1%
41	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%
37	1	< 0.1%

cancelled_hour
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	20
Distinct (%)	0.4%
Missing	444782
Missing (%)	98.8%
Infinite	0
Infinite (%)	0.0%
Mean	13.86738214

Minimum	2
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	2
5-th percentile	7
Q1	11
median	15
Q3	17
95-th percentile	18
Maximum	21
Range	19
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.558332018
Coefficient of variation (CV)	0.2565972425
Kurtosis	-0.6674073165
Mean	13.86738214
Median Absolute Deviation (MAD)	2
Skewness	-0.7504902827
Sum	72360
Variance	12.66172675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
15	871	0.2%
17	799	0.2%
16	789	0.2%
18	515	0.1%
14	491	0.1%
9	361	0.1%
8	337	0.1%
7	244	0.1%
10	231	0.1%
13	189	< 0.1%
Other values (10)	391	0.1%
(Missing)	444782	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	1	< 0.1%
4	9	< 0.1%
5	16	< 0.1%
6	58	< 0.1%
7	244	0.1%
8	337	0.1%
9	361	0.1%
10	231	0.1%
11	132	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	9	< 0.1%
19	62	< 0.1%
18	515	0.1%
17	799	0.2%
16	789	0.2%
15	871	0.2%
14	491	0.1%
13	189	< 0.1%
12	102	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	order_time	order_id	order_date	allot_time	accept_time	pickup_time	delivered_time	rider_id	first_mile_distance	last_mile_distance	alloted_orders	delivered_orders	undelivered_orders	lifetime_order_count	reassignment_method	reassignment_reason	reassigned_order	session_time	cancelled_time	total_dist	weekday	order_time_hour	accept_time_hour	first_order	delivered_fraction	accept_order_diff	weekday_num	call_total	cancelled_hour
0	2021-01-26 02:21:35	556753	2021-01-26	2021-01-26 02:21:59	2021-01-26 02:22:08	2021-01-26 02:32:51	2021-01-26 02:49:47	11696	1.566600	2.65	46.0	46.0	0.0	621.0	NaN	NaN	0.0	175.550000	NaT	4.216600	Tuesday	2	2.0	1	1.000000	33.0	1	2.0	NaN
1	2021-01-26 02:33:16	556754	2021-01-26	2021-01-26 02:33:57	2021-01-26 02:34:45	2021-01-26 02:50:25	2021-01-26 03:11:15	18117	2.520700	2.76	8.0	8.0	0.0	105.0	NaN	NaN	0.0	3.266667	NaT	5.280700	Tuesday	2	2.0	1	1.000000	89.0	1	1.0	NaN
2	2021-01-26 02:39:49	556755	2021-01-26	2021-01-26 02:39:57	2021-01-26 02:40:13	2021-01-26 02:56:00	2021-01-26 03:12:46	18623	2.207400	4.80	1.0	1.0	0.0	66.0	NaN	NaN	0.0	9.816667	NaT	7.007400	Tuesday	2	2.0	1	1.000000	24.0	1	NaN	NaN
3	2021-01-26 02:47:53	556756	2021-01-26	2021-01-26 02:48:25	2021-01-26 02:49:06	2021-01-26 03:21:51	2021-01-26 03:41:05	15945	2.189400	6.38	1.0	1.0	0.0	127.0	NaN	NaN	0.0	17.533333	NaT	8.569400	Tuesday	2	2.0	1	1.000000	73.0	1	3.0	NaN
4	2021-01-26 03:06:30	556757	2021-01-26	2021-01-26 03:07:21	2021-01-26 03:07:57	2021-01-26 03:31:38	2021-01-26 04:00:15	17589	2.787000	4.01	34.0	34.0	0.0	84.0	NaN	NaN	0.0	1.350000	NaT	6.797000	Tuesday	3	3.0	1	1.000000	87.0	1	1.0	NaN
5	2021-01-26 03:07:16	556758	2021-01-26	2021-01-26 03:12:14	2021-01-26 03:12:27	2021-01-26 03:25:36	2021-01-26 03:45:51	1469	2.481800	5.18	296.0	294.0	2.0	1506.0	NaN	NaN	0.0	175.550000	NaT	7.661800	Tuesday	3	3.0	1	0.993243	311.0	1	1.0	NaN
6	2021-01-26 03:10:50	556759	2021-01-26	2021-01-26 03:11:18	2021-01-26 03:12:05	2021-01-26 03:19:31	2021-01-26 03:26:04	8851	2.809100	3.40	45.0	45.0	0.0	1460.0	NaN	NaN	0.0	175.550000	NaT	6.209100	Tuesday	3	3.0	1	1.000000	75.0	1	2.0	NaN
7	2021-01-26 03:14:10	556760	2021-01-26	2021-01-26 03:14:38	2021-01-26 03:14:44	2021-01-26 03:33:53	2021-01-26 03:42:38	8493	0.025681	0.16	54.0	53.0	1.0	270.0	NaN	NaN	0.0	44.166667	NaT	0.185681	Tuesday	3	3.0	1	0.981481	34.0	1	NaN	NaN
8	2021-01-26 03:14:20	556761	2021-01-26	2021-01-26 03:14:50	2021-01-26 03:15:14	2021-01-26 04:00:02	2021-01-26 04:13:31	11543	2.444200	2.86	29.0	29.0	0.0	955.0	NaN	NaN	0.0	2.500000	NaT	5.304200	Tuesday	3	3.0	1	1.000000	54.0	1	NaN	NaN
9	2021-01-26 03:15:18	556762	2021-01-26	2021-01-26 03:21:27	2021-01-26 03:22:04	2021-01-26 04:14:56	2021-01-26 04:38:39	21037	2.878600	2.61	0.0	0.0	0.0	1.0	auto	Reassignment Request from SE portal.	1.0	175.550000	NaT	5.488600	Tuesday	3	3.0	1	NaN	406.0	1	NaN	NaN

Last rows

	order_time	order_id	order_date	allot_time	accept_time	pickup_time	delivered_time	rider_id	first_mile_distance	last_mile_distance	alloted_orders	delivered_orders	undelivered_orders	lifetime_order_count	reassignment_method	reassignment_reason	session_time	cancelled_time	total_dist	weekday	order_time_hour	accept_time_hour	first_order	delivered_fraction	accept_order_diff	weekday_num	call_total	cancelled_hour
449990	2021-02-06 10:03:00	130221	2021-02-06	2021-02-06 10:03:01	2021-02-06 10:04:03	2021-02-06 10:07:44	2021-02-06 10:15:03	3617	2.1965	1.24	22.0	22.0	0.0	34.0	NaN	NaN	376.416667	NaT	3.4365	Saturday	10	10.0	1	1.000000	63.0	5	NaN	NaN
449991	2021-02-06 10:03:01	130222	2021-02-06	2021-02-06 10:04:30	2021-02-06 10:06:04	2021-02-06 10:26:23	2021-02-06 10:36:09	773	1.4707	1.12	147.0	146.0	1.0	773.0	NaN	NaN	268.166667	NaT	2.5907	Saturday	10	10.0	1	0.993197	183.0	5	1.0	NaN
449992	2021-02-06 10:03:06	130223	2021-02-06	2021-02-06 10:03:47	2021-02-06 10:04:07	2021-02-06 10:15:01	2021-02-06 10:26:06	1407	0.3007	1.26	265.0	264.0	1.0	477.0	NaN	NaN	209.266667	NaT	1.5607	Saturday	10	10.0	1	0.996226	61.0	5	1.0	NaN
449993	2021-02-06 10:03:11	130224	2021-02-06	2021-02-06 10:03:12	2021-02-06 10:03:35	2021-02-06 10:15:43	2021-02-06 10:25:14	745	2.7013	3.72	200.0	200.0	0.0	290.0	NaN	NaN	229.250000	NaT	6.4213	Saturday	10	10.0	1	1.000000	24.0	5	1.0	NaN
449994	2021-02-06 10:03:14	130225	2021-02-06	2021-02-06 10:03:23	2021-02-06 10:03:43	2021-02-06 10:15:36	2021-02-06 10:34:10	7823	1.7916	2.60	202.0	201.0	1.0	1426.0	NaN	NaN	273.233333	NaT	4.3916	Saturday	10	10.0	1	0.995050	29.0	5	NaN	NaN
449995	2021-02-06 10:03:16	130226	2021-02-06	2021-02-06 10:03:44	2021-02-06 10:04:14	2021-02-06 10:27:29	2021-02-06 10:44:08	1006	0.5789	0.19	4.0	4.0	0.0	127.0	NaN	NaN	369.516667	NaT	0.7689	Saturday	10	10.0	1	1.000000	58.0	5	1.0	NaN
449996	2021-02-06 10:03:17	130227	2021-02-06	2021-02-06 10:03:18	2021-02-06 10:04:34	2021-02-06 10:22:17	2021-02-06 10:31:43	279	1.9863	1.19	81.0	81.0	0.0	105.0	NaN	NaN	239.133333	NaT	3.1763	Saturday	10	10.0	1	1.000000	77.0	5	1.0	NaN
449997	2021-02-06 10:03:18	130228	2021-02-06	2021-02-06 10:04:06	2021-02-06 10:04:39	2021-02-06 10:19:06	2021-02-06 10:26:56	3161	1.5944	1.61	28.0	28.0	0.0	1488.0	NaN	NaN	204.150000	NaT	3.2044	Saturday	10	10.0	1	1.000000	81.0	5	2.0	NaN
449998	2021-02-06 10:03:19	130229	2021-02-06	2021-02-06 10:03:19	2021-02-06 10:05:41	2021-02-06 10:20:39	2021-02-06 10:30:41	9396	2.8939	4.68	72.0	72.0	0.0	105.0	NaN	NaN	65.583333	NaT	7.5739	Saturday	10	10.0	1	1.000000	142.0	5	4.0	NaN
449999	2021-02-06 10:03:24	130230	2021-02-06	2021-02-06 10:03:45	2021-02-06 10:05:14	2021-02-06 10:13:26	2021-02-06 10:19:41	2078	1.8925	0.09	30.0	30.0	0.0	108.0	NaN	NaN	212.000000	NaT	1.9825	Saturday	10	10.0	1	1.000000	110.0	5	1.0	NaN

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values